# -*- coding:utf-8 -*-
"""
Author：Administrator
Date:2021年10月12日
"""
import pandas as pd

path = '../数据文件/课件020/多层索引.xlsx'
data = pd.read_excel(path, sheet_name='无序',index_col=[0,1])
data = data.sort_index(level='科目')
data2 = data.loc[('语文', slice(None)),:]


# print(data)
# print(data.index.is_lexsorted())
print(data2)